package com.woniuxy.depot.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.woniuxy.depot.model.DTO.StockGoodsDTO;
import com.woniuxy.depot.model.VO.StockGoodsVO;
import com.woniuxy.depot.model.entity.DepotStockManage;
import com.woniuxy.model.vo.DepotStockManageVo;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface DepotStockManageMapper extends BaseMapper<DepotStockManage> {

    int getTotal(StockGoodsDTO stockGoodsDTO);


    List<StockGoodsVO> getGoodsList(StockGoodsDTO stockGoodsDTO);

    void updateNum(DepotStockManage stockManage);

    boolean delStock(DepotStockManageVo stockManageVo);

    @Insert("insert into export_table values(null,#{account},now(),#{tableName})")
    Boolean insertExcel(@Param("account") String account,@Param("tableName") String tableName);
}
